﻿CREATE TABLE [dbo].[User_Info] (
    [UserName] VARCHAR (100) NOT NULL,
    [PassWord] VARCHAR (100) NULL,
    [FullName] NVARCHAR (10) NULL,
    [Type]     SMALLINT      CONSTRAINT [DF_User_Info_Type] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_User_Info] PRIMARY KEY CLUSTERED ([UserName] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0:管理员 1:数据录入员 2:设备管理员', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'User_Info', @level2type = N'COLUMN', @level2name = N'Type';

